<html>
<head>
<title>Login page</title>

</head>
<body>
<?php include 'logintop.html'; ?>
<div align=center>
<p>
<form name=loginForm action="CheckLogin.php" method=POST>
	<table border=1 cellpadding=3>
	<tr>
	<th>User Name:</th>
	<td><input type="text" name="uname" size=20 /> </br></td>
	</tr>
	<tr>
	<th>Password:</th>
	<td><input type="password" name="password" size=20 /> </br> </td>
	</tr>
	<tr>
	<td colspan=2>
	<b>Year:</b> 
	<select name="selectYear">
	    <?php
			require_once 'commonutils/db/DBConnectionManager.php';
			$sqlquery = " select distinct year from semester order by year desc ";
			$result = DBConnectionManager::query($sqlquery);

			while($row = mysql_fetch_assoc($result)){
				echo "<option value=".$row['year'].">".$row['year']." </option> ";
			}
	    ?>
	</select>
    &nbsp;&nbsp;   
	<b>Semester:</b> 
	<select name="selectSemester">
	    <option value="Spring">Spring</option> 
	    <option value="Summer">Summer</option>
	    <option value="Autumn">Autumn</option>  
	</select>	
	</td>
	</tr>	
	<tr>
	<td colspan=2 align=center>
		<input type="submit" value="  Login  " />
	</td>
	</tr>  	
	</table>	    
</form>
</p>
</div>

</body>
</html>